﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetPermisosByUsuarioAndFormulario')
	BEGIN
		DROP  Procedure  GetPermisosByUsuarioAndFormulario
	END

GO

CREATE Procedure GetPermisosByUsuarioAndFormulario

	(
		@idEmplerado int,
		@idFormulario int
	)

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[Estado],
	[IdEmpleado],
	[IdFormulario],
	[TipoPermiso]
	FROM [Permiso] 
	WHERE [IdEmpleado] = @idEmplerado AND [IdFormulario] = @idFormulario

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetPermisosByUsuarioAndFormulario TO PUBLIC

GO

